Zomato Project

Importing Library and reading data

Data Cleaning

The average cost for two column has some 0 values which is improper. Lets try removing those datas

Merging the country sheet and zomato file to get the country code

Lets list all the country now and do analysis

2) Get the Top rated restaurants in each city in India

- Get the cities in india

Top restaurant in delhi based on the rating and vote count

Finding out relationship between the rating and votes

There is a bit linear relationship between rating and the votes although not much, voting influences the rating

Number of Restaurants in India

Top 5 restaurants with online delivery in New Delhi

Cheap but best restaurants available in a city

Lets check which country is providing most online delivery option

Look for the cheap but best restaurants available in a New Delhi

Top cuisines in each region.

Aggregate rating of all the restaurants in each city in India

Calculating the restaurants rating based on the rating text with percentage

Does rating influences the cost of restaurant?

The plot shows rating does influence the cost of a restaurant

Top Percentage cover of restaurants in a city.

Top cuisines in Indian restaurants.